2015-09-21 - 22010 - Service Request - DSCO207 report duplicate records #CrystalReportsSupport
Service Request
22010 - DSCO207 report failed
Problem Summary
Need to fix DSCO207 report that failed in BI Production.
Admin Info
| Purpose |
Need to fix DSCO207 report failed in BI Production. |
| Requested by |
Baiwa Zhang |
| Issue Date |
09-21-2015 |
| Resolved by |
Dhananjay G |
| Resolved Date |
09-29-2015 |
| Document Status |
Complete |
Detailed Problem Description
Email from Baiwa Zhang on 09-21-2015:
Recently our DSSCO source DSCO207 failed quite frequently for the following error. Can you please let your team take a look?
Solution Analysis and Recommendations
1. Need to check the report error in BI Launchpad.
2. Need to analyze DSCO207 scheduling issue.
3. Need to update the data sources in the report.
4. Need to check DSCO207 is using an infoset query ZMM_MIGOREGPOS from NEP with three optional parameters.
5. Observed that the report output contains duplicate records i.e. each record prints twice.
Test Plan
| Test ID |
Test Scenario |
Expected Results |
| 1 |
Report Format. |
Should be as per NEC crystal standard checklist. |
| 2 |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3 |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Resolution
1. Analyzed the DSCO207 scheduling issue in BI Launchpad.
2. Updated the data sources in the report.
3. Observed that the report output contains duplicate records i.e. each record prints twice.
4. Applied groupings(ZMM_MIGOREGPOS.EKET-ETENR and ZMM_MIGOREGPOS.EKPO-MATNR) on the DSCO207 report that has cut down the execution time by half by eliminating the duplicate records.
Release Information
None